cript steps to accomplish this: Perform Find, Sort, Go to Layout, and Enter Preview Mode. For details on creating scripts, see chapter 5, "Using ScriptMaker and Buttons," in the FileMaker Pro User's Guide.
3. In Layout mode, select the button named "Your Own Report."
4. Choose Button... from the Format menu.
5. Select Perform Script from the list of commands.
6. Choose the script that you defined in step 2 from the Specify Script pop-up menu.
7. Click OK to clo
are copies of the template examples that include data, to Jtallow you to see how the templates work. These files are located in the Examples folder in the FileMaker Pro folder.
HBAM3016AUG95@
4/9/99
4/9/99
4/9/99
4/9/99
/30/98
P couldn't be initialized (:the manually set TCP/IP address is configured improperly (Jthe TCP/IP address is already in use or an address could not be obtained (
; This file is created and used by FileMaker Pro for TCP/IP access.
; It should contain one IP address or host name per line.
; Lines starting with a semicolon are ignored.
FileMaker Hosts
Local Hosts
Specify Host...:FileMaker host name is limited to 32
Pro 2.0 - 2.1F!
Pro 3.0 - 4.0
APPROVED BY
CREATED BY
DATE APPROVED
DATE CREATED
DATE EMPLOYEE SIGNED
DATE FRIDAY
DATE MODIFIED
DATE MONDAY
DATE OF REQUEST
DATE THURSDAY
DATE TUESDAY
DATE WEDNESDAY
DEPARTMENT
EMPLOYEE ID
EXPLAIN OTHER
FIRST NAME
HILITEDEPARTMENT
HILITEEMPLOYEEID
HILITEFIRSTNAME
HILITEHOURS
HILITELASTNAME
HILITELIBRARY
HILITESORTEDBY
HILITEWEEK
J LAST NAME
LEAVE HOURS FRIDAY
LEAVE HOURS MONDAY
LEAVE HOURS THURSDAY
LEAVE HOURS TUESDAY
LEAVE HOURS WEDNESDAY
LEAVE ID
TEMPLATE INFORMATION GLOBAL
TOTAL
TOTALS HOURS LEAVE FOR WEEK
WEEK ENDING
Pro 2.0 - 2.1F!
Pro 5.0M1
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
January
February
March
April
August
September
October
November
December
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
dVeQdR
5/31/2000
About FileMaker Pro templates
These sample files are provided to help you get results quickly with FileMaker Pro. You can use the files immediately by deleting the existing records and adding your own and using the provided layouts and reports. Or, you can customize the files by adding or changing fields or layouts. Click the buttons at the top to view layouts and reports.
Description
Use this database template to track employee leave requests.
How to use this template
Your employees c
an enter information directly into the database, or create and print a blank record and complete the form by hand.
Tips for customizing this template
You can create a relationship to your personnel database file (based on the Employee ID field) to retrieve values for First Name, Last Name, and Department.
Printing a Report
Click on the Reports button. Select a report to preview. Choose Print from the File menu. After printing, click the Continue button.
Date of RequestB
Created ByB
Week EndingB
X_The date entered into the "Week Ending" field must fall on a Friday and contain a 4-digit year.
Day 2B
Day 3B
Day 4B
Day 5B
Date 1B
, - 4
Date 2B
, - 3
Date 3B
, - 2
Date 4B
, - 1
Date 5B
Totals Across WeekB
TotalB
Explain OtherB
Date Employee SignedB
Template Information GlobalB
HiliteSortedByB
HiliteLibraryB
HiliteFirstNameB
D = "firstNameA"
D = "firstNameD"
"")
firstNameA
firstNameD
HiliteLastNameB
D = "lastNameA"
D = "lastNameD"
"")
lastNameA
lastNameD
HiliteEmployeeIDB
D = "employeeIDA"
D = "employeeIDD"
"")
employeeIDA
employeeIDD
ListB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Enter number of leave hours
first
scott
Date Signed
Date Approved
Approved By
Enter data for Employee Leave
Subtotals
Vacation
Vacation Cash Out
Sick Leave
Unpaid Time Off
Personal Holiday
Other Reason*
Total
*Explain Other
Date
*Explain Other
Date
LK=31013$$-,)'
'@,
#/9?A7-CKNQQPONMKJJMN
KB'&&%03-1,!$($
!)7?B?4'DLN
O KHKONOPGENMHG)#"
.40/
&2<BBDD'*GL=27<G
PKMNMEC3$"
"# #%!
)7DEDCG$
IE5('$"
+9JI@@,
)78?MOI9.0@?28=4'.*(#
"$53*
& #$!
'8IH?0//"
.@?7>G=0'(-1
"!,+*10.(
!/99-
LHRQ&!
#('+)(%!
%8JG?/32!
*626FE1
",35-"
$(,44$
LHRQ"!
"0/F<..,
/70!!
,.)#%'
*/&%9700,#
+:5""
57,$=B335)
,:6.$
*9=0#""
'291.&ID6.-,&(
'=@;(
(-<>:.++.35."
+)7=359.3G@",
.B=B3
)9@@B?<747?<7+'0672$
#,0927?DD%AE$$,
Delete
Delete
Delete
Delete
Leave Request FormB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
HoursV
WeekW Last NameX
First Name
Reports
Delete
S1Click to see more information for a business card
Record @@ of <<
ABED>>
Emp. ID
Department
Reports
Delete
S3Click arrow to see more information for an employee
more information for an employee
employee's leave form
InformationB
Yesfter
Noarter
c3Please return completed form to payroll department.
Manager Signature
Employee Signature
Rev. 12/16/98
**Explanation for Other Reason
*You may convert full days of vacation into cash. This option is available to you only at the time that you take a vacation, and you must use at least as many vacation days as you are trading for cash.
Dates:
Total Hours:
Other Reason**:
Personal Holiday:
Unpaid Time Off:
Sick Leave:
Vacation Cash Out*:
w Vacation:
x Subtotals
Department
Emp. ID
{ Last Name
First Name
Week Ending (Friday)
Exempt Leave Request Form
Company Name and Logo
Report
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
ReportsB
Sort By First Name
D = "firstNameA"
firstNameA
D = "firstNameD"
firstNameD
"firstNameA"
firstNameA
Sort by First Name Descending
"firstNameD"
firstNameD
Sort by Employee ID Descending
Sort by Department Descending
A&Sort by Date of End of Week Descending
Sort by Total Descending
Sort By Last Name
O3Information about the Employee Leave Forms Template
Reports
Info for this Templatel
;E?710..
LHRQ*$
%,'"'@C@=95$
",../15:=A8:756973&)0
%3;CD9BA7,'$!
%69;70/BE<44640
LHRQ#
%+$%(@D@><83
*..0177=GJD931277,%@.
.<HD=BI@7,''+,.08;671.2<7:994.
'?/CD@><95*
(../1767=B:8;40+.,
%3@@=FKIC3.0:9:<=;072+,/,+583,
*<BDFE@><973'+-,,022.26119973&(!19)
,47DKMJ@7-19:9;,9:7.('&&/:83+
LHRQ#%"
,GIFFD@=;:7420/+')'
$39=@967.).6AE.$17JKJD;/-0403<'/1"#%&'0:9:30
LHRQ""
+KKGFDA<<97431-*($#
.48AA=63007>DHK,,7IJFA:'%,339:/8."$%(,289871
BDEG@>?<973
2/,# "%(-037<=>93007=AEJFAHGD@=."
(5=8*#6."#$().0-./,
,5AACG?;?<9742-
%(*.-/.+*297/-,29>DHGHFCA=;.")7@@;5##""#%$'*)#
'JLHEEF>29<9853/$$'+,*#
"&*$$',0;>DGDFB>;
8=@DB9*""$&""('
"(9LJGGF=25;9863.)+)'$
"$$**(.7>BEGGDA<99;>A@DF@8%0$$,#!,'#"
@KIF:..689:6-
&$'&/449<DGJJGD@==>@CFGHF@=+(' 0.
LHRQF0
!&C;'"!
,.587-
'.+'0:<ACGLNFAIFDCCDHFIKE?<89"'
L+RQ0#!"#&""#"
""(32(#*'#
",28;=:9EINQPIKKI
7) = 5
Leave Hours MondayB
Leave Hours TuesdayB
Leave Hours WednesdayB
Leave Hours ThursdayB
Leave Hours Friday - 4
Date TuesdayB
, - 3
Date WednesdayB
, - 2
Date ThursdayB
, - 1
Date FridayB
Totals Across WeekB
TotalB
Your Own
ReportB
Your Own ReportC
Your Own ReportD
Leave Request FormW>Click on any of these buttons to preview the respective reportX
Select a report
Reports
Web ListB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
11/24/98k
Scott Yu
Reports
Reports
Sort by First Name Ascending
"firstNameA"
firstNameA
Sort by Employee ID Ascending
"employeeIDA"
employeeIDA
Helvetica
Geneva
Times
Times New Roman
Arial
MS Sans Serif
)=400
Cancel
You did not enter any find criteria; all records will be displayed.C)
Cancel
No records match this request.E)
Open Script
Clear Sort Indicator
Go to Form Layout
Go to Information Layout
Go to List Layout
Go to Reports Layout
Sort By First Name
Sort By Last Name
Sort By Employee ID
Sort By Department
Sort By Date of End of week
Sort By Total
Sort by First Name Ascending
Sort by First Name Descending
Sort by Last Name Ascending
Sort by Last Name Descending
Sort by Employee ID Ascending
Sort by Employee ID Descending
Sort by Department Ascending
Sort by Department Descending
0%Sort by Date of End of Week Ascending
2&Sort by Date of End of Week Descending
Sort by Total Ascending
Sort by Total Descending
Leave Request Form
Your Own Report
Open Home imported
Sort By Date of End of week
D = "endOfWeekA"
endOfWeekA
D = "endOfWeekD"
endOfWeekD
"endOfWeekA"
endOfWeekA
Sort By Total
D = "totalHoursA"
totalHoursA
D = "firstNameD"
firstNameD
"firstNameA"
firstNameA
Clear Sort Indicator
wwwwww
ffffff
UUUUUU
DDDDDD
3333B
""""""
#11#22122"3!
"#""3"129
C3C3C34C4C3CC43C
DDCD4DD4CDDC
4CDD4E4ET
TEETEETUETUETUDUDEETUDTUE[
dUTeETeETeEUFTUTUFTUUTeK
EUeFFEUFEUFFUeTeVFeUUdVEEk
ffFdeefeefddfDeVdfEdfFdffk
eVefefe
VvffVefVVefUe\
fvfgfwffv
ggvgvv
gvwxgwghg
vhgvvww
9MSPC
MSPCA
NAMEA
RPTHA+:::Applications:FileMaker Pro 5 Folder:home
tions:FileMaker Pro 5 Folder:home
Sort By Employee ID
D = "employeeIDA"
employeeIDA
D = "employeeIDD"
employeeIDD
"employeeIDA"
employeeIDA
Sort By Department
D = "departmentA"
departmentA
D = "departmentD"
departmentD
"departmentA"
departmentA
D = " firstNameA"
firstNameA
D = " firstNameA"
firstNameA
NameA
lastNameD
"lastNameA"
lastNameA
Sort by Last Name Ascending
"lastNameA"
lastNameA
A%Sort by Date of End of Week Ascending
"endOfWeekA"
endOfWeekA
Leave Request Form
Open Script
Sort by Last Name Descending
"lastNameD"
lastNameD
Sort by Employee ID Descending
"employeeIDD"
employeeIDD
Sort by Department Descending
"departmentD"
departmentD
A&Sort by Date of End of Week Descending
"endOfWeekD"
endOfWeekD
Sort by Total Descending
"totalHoursD"
totalHoursD
Sort By Last Name
HiliteDepartmentB
D = "departmentA"
D = "departmentD"
"")
departmentA
departmentD
HiliteWeekB
D = "endOfweekA"
D = "endOfweekD"
"")
endOfweekA
endOfweekD
HiliteHoursB
D = "totalHoursA"
D = "totalHoursD"
"")
totalHoursA
totalHoursD
D = "lastNameA"
lastNameA
D = "lastNameD"
lastNameD
"lastNameA"
lastNameA
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Helvetica
Geneva
Times
Times New Roman
Arial
MS Sans Serif
Verdana
Sort by Total Ascending
"totalHoursA"
totalHoursA
Sort by Department Ascending
"departmentA"
departmentA
Helvetica
Geneva
Times
Times New Roman
Arial
MS Sans Serif
UUUUUU
wwwwww
LHRQ:996)('),$
+HB>2',&
'1677653/$
!$',4731-(
&./035>F3
MPH2,5
LHRQ=DD@837993-9H>6-+.
!(/670120'!$&&')2841/,"
"*-24<KH3&
FPN-,5
").0"%$373!
)3750'+3
LHRQ.,--)#
+4?EF@"
$-/,'(),)
$,/00/
CD?9:80+))'$
'*//-+&"$*$4EA7-+)!
)FMB"
71'0>GC;647/*)'($
*/30,2102338HE<6/,+'
LHRQ
"@L@0
$1@G@7010'$**(%
!"$&"'0477867357;GG965330-
%0:HG:.*6DA
"-@G@70.&,%('$"
"%('&(/1220.,3;9>MQK9,07<:5
+3=DF<308@?
*;GB:32(-,#$"
"$'*'$$,'&),..29?GPQK4$#1@?<
LHRQ"
'.13$!48300
&3DD930'.,(%"
('%"!"&+..07<BIOPD3%"/BBA
LHRQ1
#,")$
,=E;/'./,'%!
'")'#
&,--06
8<>DPIA3-2@BA
LHRQ8(
#1@=0-30.,$
$*+'#
!&+-0..,-04EE<?75@@=
LHRQ73#
,-..%
'7?3/20.*&
&)33$
"&)+*'$('*-=22@CDE=8
L3RQ86/,,#
+/,)+#
19730.,*'"
'+00%
&(860<BD<:=
LHRQ741+
*342/,*''&
)"',-,$
$'0229=?37A
LHRQ41-*
$,.)#
"&$"
"')$+45-$!
1/*)-79;-.=
LHRQ2/,'$$"
$*89/$#!
#=4$'/588.(3
LHRQ0,,)$#!
"! #1?C99C>@932BGHD>=@?:349;7,
"$&'38@>39DJKA!3"
'/577@GG@;=@<30.1>DFKGGEB??AA<5.
(8A7!
!)('*,3-0??7=GKJF3
.7,"&.13<DFECBBA4=30.9C@DKJ@@FFD@=72+
LHRQ#5A@6
)4::3,-41&,@96=KKID>0
*990+--
5=99?@;1=10.1>BJKLEBDFC>94,!
LHRQ0?BA@79@@A=81/340.9C947QKHDA?%
;=7,/.
#(.459=;0//'5>JLNGCBAA=80&
L-RQ3A@>;968@@?81143,*;=:5CQKGD??7
;97/..
/70--)'3@GHGB=>?>:/#
K=RQ.;;7537A>?@=789:3(
3IQQKDB>;@0'=821,*!
&++,..$+7=EE@
RQ.02038?<8>=63
5@FQOGCA=;=B<>7.)$!
""$',."39A>;832797*
LHRQ01204;>?=<3"$4/350#09?GEDBBC?=?@;0,("
(0,#.773.$
L.RQ133217;<:64*.'
55(%&1@CBBIJD=<81-,'()''
",10763/*
LHRQ,03149;94.,+$
8>4-(.<@AAGKEA>70.,-/+'%
',/-)$"#"
LHRQ,,/4;9850'"
)@E@937=@?ABFB>94/..0/&
',.00$
RQ&"!$.,+,,$
'AB;D98>
@-B@?=:3/.,+)"
"032.(#
2C?C9<
UUUUUU
wwwwww
LHRQ:996)('),$
+HB>2',&
'1677653/$
!$',4731-(
&./035>F3
MPH2,5
LHRQ=DD@837993-9H>6-+.
!(/670120'!$&&')2841/,"
"*-24<KH3&
FPN-,5
D lastNameDAA
Employee IDB
A Last NameB
First NameB
DepartmentB
Approved ByB
Date ApprovedB
Date CreatedB
Date ModifiedB
Leave IDB
HRQ=FEHGEEDGIKKG==?0-$
$'&$)//)%"$$($
0720.+)
$-0..:=47*
7MNE.3
RQ@HHGJI
G=IJH@;GC3/1..(
".2.'$%##'**250.+')%
00+(%
"'00,
'NHQ:4
LHRQHKGCGDBBEHJB4-AC/0352' !)0.(#$$#*14740.+($(!
&(#$"
)MKNJ9
LHRQHD@>>=89@HKD3/++8>97/&&$
#$/7=830-+&"%#"
'08DIHEND
LHRQB83347339EKD4.+6DE<3.&&""*)
#..782.,'(%""
$.9DC97N
LHRQ4,'+37217@D43.,3@C93/'%
)073(('+*(#!
)6>8.9
'330:AB?40,*'$
!'/63#
$.*$%!
.5:06
LHRQ"
",64<@C=1,'&&('$&+,!
$,.-20"
!*'%"
,073=
$,12-;?>4&$"
#,-/)
&370-.)!
%.+&$&.2,
!641/2
LHRQ$#
(3:64.59:6#
"36700+"
+78/)6>95(
.+&$"
$7C:1..
LHRQ"!!
(39=><50..1.''*"
57,+.+#
2BG7&3>9:' .'(
",.7FE87D6
L RQ0'$! &*;
A;>4,.
',(&,.09@3"':>2)&*!
2@DE1;=9.&$$
/,'/63/=B=;EG3
LHRQ0'"
'(&7@@A=9&
%,,+.05<=.'6;:3030
#699C?647,+("
278720
esfter
Noarter
esfter
Noarter
Yesfter
Noarter
5/20/1999i
1j 5/20/1999k
Dave Heiberl
12/24/1999w
12/20/1999x
12/21/1999y
12/22/1999z
12/23/1999{
12/24/1999
23/99k
Scott
/22/99i
3/22/99k
Scott
3/22/99Y
3/22/99i
3/22/99k
Scott
3/22/99Y
3/22/99i
3/22/99k
Scott
3/22/99Y
3/22/99i
3/22/99k
Scott
3/22/99Y
3/22/99i
3/22/99k
Scott
3/22/99Y
3/22/99i
3/22/99k
Scott
3/22/99Y
3/22/99i
3/22/99k
Scott
3/22/99Y
3/22/99i
3/22/99k
Scott
3/22/99i
3/22/99k
Scott
3/22/99Y
3/22/99i
3/22/99k
Scott
3/22/99Y
3/22/99i
3/22/99k
Scott
3/22/99Y
3/22/99i
3/22/99k
Scott
3/22/99Y
3/22/99i
3/22/99k
Scott
amest Name
Emp. ID
Department
HoursV
WeekW Last NameX
First Name
Emp. ID
Department
Dept.
Week Ending
Employee Leave
Reports
First Name
Last Name
Emp. ID
Leave Request Form
Information
Reports
Web List
Web Form
FormB
Go to List Layout
Your Own Report
Cancel
Create your own script and attach it to this button.